select * from products where pro_name like '%Quinceanera%dress%with%tail%' or pro_des like '%Quinceanera%dress%with%tail%'union all select * from products where (pro_name like '%Quinceanera%' or pro_des like '%Quinceanera%') or(pro_name like '%dress%' or pro_des like '%dress%') or(pro_name like '%tail%' or pro_des like '%tail%') and (pro_name not like '%Quinceanera%dress%with%tail%' or pro_des not like '%Quinceanera%dress%with%tail%')
Hunter Green Organza Quinceanera Dress with Boning Details and Ruffles for Miss Freedom Of The World
Taffeta Quinceanera Gown with Strapless Neck and Appliques
Multi-Color Sweetheart Quinceanera Gowns with Appliques and Ruffles
Dark Green Quince Gown with Bodice by sequined Fabric and Ruffled Skirt
Yellow Quinceanera Dress by Taffeta and Organza with Beading and Ruffles
Yellow Green Organza Quinceanera Dress with Sweetheart Neck and Beading
Teal Taffeta Quinceanera Gown with Sweetheart Neckline and Appliques
Apple Green Quinceanera Dress by Taffeta with Beading and Pick-ups
Spring Green Strapless Quinceanera Gown dress by Organza with Pick-ups
Aqua Blue Sweetheart Quinceanera Gown Dress by Sequined Fabric for 2013
Lavender Tulle Quince Dress with Ruched Bodice and A-Line / Princess Skirt
Strapless Sweet Sixteen Dresses by Tulle with Appliques
Spring Green Sweetheart Quinceanera Gowns with Ruches and Ruffled Skirt
Green and Pink One Shoulder Quince Dress with Beading and Ruffles
Multi-Color Quinceanera Dress with One Shoulder Neck and Ruffled Skirt
Yellow Organza Quinceanera Gown with Strapless Neck and Beaded Top
Orange Sweetheart Organza Quinceanera Dress with Appliques and Ruffles
Purple and Fuchsia Sweet 16 Dresses with Spaghetti Straps and Ruffles
Hot Pink Sweet 15 Dresses with Appliques and Ruffled Layers for 2014
Fuchsia Strapless Dress For Quinceaneras with Appliques and Ruffles
Blue Dress For Quinceanera by Taffeta and Tulle with Lace Appliques
Rose Pink Tulle Quinceanera Dress with Sweetheart Neckline and Appliques
2014 Fuchsia Taffeta Sweet Sixteen Dresses in Floor-length with Ruches
Turquoise Quinceanera Dress by Taffeta with Appliques and Pick-ups
Grey Organza Sweetheart Quinceanera Dress with Appliques and Pick-ups
White A-line Halter Quinceanera Dress with Beading and Hot Pink Sash
Olive Green and Gold Sweet 16 Dresses by Taffeta and Tulle with Beading
Wine Red Strapless Quinceanera Dress by Taffeta with Appliques for 2013
Apple Green and Black Quinceanera Dress with Embroidery and Flowers
Satin Organza Embroidery Sky Blue Ruffled Quinceaneras Dress